Paul Newcome
Paul Newcome
-
Re: Return sum of one column if today's date is between A and B, etc
While this is technically correct, there are actually a number of ways to make this easier for you. The most immediate is by removing the need to hard code whether a month has 28, 29, 30, or 31 days …1 · -
Re: Calculate the sum for each month.
@NickStaffordPM You can use the criteria from my formula in same sheet formulas as well to avoid needing the extra columns. =SUMIFS(Cost:Cost, Status:Status, @cell = "STARTED", Date:Date, A…1 · -
Re: Can Free Users add or edit records via the details pane of a Dynamic View?
Anyone that has access to the DV should be able to edit so long as you have those fields set to be editable in the DV settings. Same with adding rows. Anyone that has access should be able to add row…1 · -
Re: Help with INDEX/COLLECT with a MAX/COLLECT
In that case you will need to insert a helper column that houses the MAX/COLLECT, and then you would reference this column in the OR function.1 · -
Re: Viewing a Smartsheet form submission in the form it was submitted through
If you open the row menu and select "Edit", the fields will be displayed in a vertical format more like a form.1 ·
